<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html
  PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xml:lang="en-us" lang="en-us">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<meta name="copyright" content="(C) Copyright 2005"/>
<meta name="DC.rights.owner" content="(C) Copyright 2005"/>
<meta name="DC.Type" content="concept"/>
<meta name="DC.Title" content="Adding a JDBC Driver"/>
<meta name="DC.Creator" content="Paula Toth"/>
<meta name="DC.Creator" content="Sandra Wagner"/>
<meta name="DC.Format" content="XHTML"/>
<meta name="DC.Identifier" content="conceptId"/>
<link rel="stylesheet" type="text/css" href="./commonltr.css"/>
<link rel="stylesheet" type="text/css" href="./pentaho.css"/>
<title>Adding a JDBC Driver</title>
</head>
<body id="conceptId">


    <h1 class="title topictitle1">Adding a JDBC Driver</h1>

    
    <div class="body conbody">
        <div class="section">
            <p class="p">The BA Server needs the appropriate driver to connect to the database that stores your data. Your database administrator, Chief Intelligence Officer, or IT manager should be able to provide the appropriate driver. If not, you can download drivers from your database vendor's website. The <a class="xref" href="http://infocenter.pentaho.com/help/topic/supported_components/reference_jdbc_drivers.html">Supported Technologies</a> section contains a list of drivers.</p>

        </div>

        <div class="section"><h2 class="title sectiontitle">Backing up old drivers</h2>
            
            <p class="p">There should be only one driver for your database in this directory. Ensure that there are no other versions of the same vendor's driver in this directory. If there are, back up the old driver files and remove them to avoid version conflicts. This is a concern when you are adding a driver for the same database type as your Pentaho BA repository. If you have any concerns about how to proceed, contact <a class="xref" href="http://infocenter.pentaho.com/help/topic/getting_support/concept_getting_support.html">Pentaho support</a>.</p>

        </div>

        <div class="section"><h2 class="title sectiontitle">Installing JDBC drivers</h2>
            
            <p class="p">Once you have the correct driver, copy it to this directory for the BA Server: </p>

            <div class="p">
                <pre class="pre codeblock">/pentaho/server/pentaho-server/tomcat/lib/</pre>

            </div>

        </div>

        <div class="section"><h2 class="title sectiontitle">Restarting</h2>
            
            <p class="p">Once the driver JAR is in place, you must restart the server or client tool that you
                added it to.</p>

        </div>

        <div class="section"><h2 class="title sectiontitle">Driver for Microsoft SQL Server</h2>
            
            <p class="p">If you are using a Microsoft SQL Server (MSSQL), you might need to use an alternative, non-vendor-supported driver called JTDS. Contact <a class="xref" href="http://infocenter.pentaho.com/help/topic/getting_support/concept_getting_support.html">Pentaho support</a> to ensure that you are adding the correct driver.</p>

            <p class="p">For Microsoft Windows, most JDBC drivers support Type 2 integrated authentication through the <span class="ph filepath">integratedSecurity</span> connection string property. To use integrated authentication, copy the <span class="ph filepath">sqljdbc_auth.dll</span> file to all machines and directories to which you copied the JDBC driver. You can find this file in this location. </p>

            <div class="p">
                <pre class="pre codeblock">&lt;installation directory&gt;\sqljdbc_&lt;version&gt;\&lt;language&gt;\auth\</pre>

            </div>

            <div class="p">
                
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="conceptId__table_zvv_by2_wk" class="table" frame="border" border="1" rules="all">
                        <thead class="thead" align="left">
                            <tr class="row">
                                <th class="entry" valign="top" id="d813e103">If running:</th>

                                <th class="entry" valign="top" id="d813e106">Use the sqljdbc_auth.dll file here:</th>

                            </tr>

                        </thead>

                        <tbody class="tbody">
                            <tr class="row">
                                <td class="entry" valign="top" headers="d813e103 d813e106 ">32-bit Java Virtual Machine (JVM) even if the operating system is version x64</td>

                                <td class="entry" valign="top" headers="d813e103 d813e106 ">x86 folder</td>

                            </tr>

                            <tr class="row">
                                <td class="entry" valign="top" headers="d813e103 d813e106 ">64-bit JVM on a x64 processor</td>

                                <td class="entry" valign="top" headers="d813e103 d813e106 ">x64 folder</td>

                            </tr>

                            <tr class="row">
                                <td class="entry" valign="top" headers="d813e103 d813e106 ">64-bit JVM on an Itanium processor</td>

                                <td class="entry" valign="top" headers="d813e103 d813e106 ">IA64 folder</td>

                            </tr>

                        </tbody>

                    </table>
</div>

            </div>

        </div>

    </div>


</body>
</html>